Overview

Dataset info

Number of variables35
Number of observations83714
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory22.4 MiB
Average record size in memory280.0 B

Variables types

Numeric21
Categorical6
Boolean8
Date0
URL0
Text (Unique)0
Rejected0
Unsupported0

Warnings

availability_365 has 28598 (34.2%) zeros Zeros
bedrooms has 5142 (6.1%) zeros Zeros
calculated_host_listings_count_entire_homes has 30756 (36.7%) zeros Zeros
calculated_host_listings_count_private_rooms has 40081 (47.9%) zeros Zeros
calculated_host_listings_count_shared_rooms has 82697 (98.8%) zeros Zeros
cleaning_fee has 26834 (32.1%) zeros Zeros
days_from_last_review has 20338 (24.3%) zeros Zeros
extra_people has 51037 (61.0%) zeros Zeros
number_of_reviews has 20108 (24.0%) zeros Zeros
number_of_reviews_ltm has 34474 (41.2%) zeros Zeros
review_scores_rating has 21757 (26.0%) zeros Zeros
reviews_per_month has 20108 (24.0%) zeros Zeros
security_deposit has 48622 (58.1%) zeros Zeros

Variables

accommodates
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean3.149807679
Minimum1
Maximum16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q12
Median2
Q34
95-th percentile7
Maximum16
Range15
Interquartile range2

Descriptive statistics

Standard deviation1.947798258
Coef of variation0.6183864084
Kurtosis3.983278408
Mean3.149807679
MAD1.537853104
Skewness1.615286528
Sum263683
Variance3.793918052
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=16)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 11.5 12.5 14.5 15.5 16. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2 35580 42.5%
 
4 16768 20.0%
 
1 10507 12.6%
 
6 6594 7.9%
 
3 5819 7.0%
 
5 3956 4.7%
 
8 1945 2.3%
 
7 1257 1.5%
 
10 464 0.6%
 
9 386 0.5%
 
Other values (6) 438 0.5%
 

Minimum 5 values

ValueCountFrequency (%) 
1 10507 12.6%
 
2 35580 42.5%
 
3 5819 7.0%
 
4 16768 20.0%
 
5 3956 4.7%
 

Maximum 5 values

ValueCountFrequency (%) 
16 68 0.1%
 
15 17 < 0.1%
 
14 67 0.1%
 
13 41 < 0.1%
 
12 161 0.2%
 

amenities_count
Numeric

Distinct count88
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean21.16041522
Minimum2
Maximum92
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile9
Q114
Median19
Q327
95-th percentile39
Maximum92
Range90
Interquartile range13

Descriptive statistics

Standard deviation9.535834864
Coef of variation0.4506449785
Kurtosis1.786043857
Mean21.16041522
MAD7.466646197
Skewness1.044134355
Sum1771423
Variance90.93214655
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 2. 2.5 4.5 5.5 6.5 ... 54.5 58.5 61.5 73.5 92. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
16 4532 5.4%
 
15 4392 5.2%
 
14 4386 5.2%
 
17 4282 5.1%
 
18 3964 4.7%
 
13 3910 4.7%
 
19 3740 4.5%
 
12 3437 4.1%
 
20 3422 4.1%
 
21 3254 3.9%
 
Other values (78) 44395 53.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 421 0.5%
 
3 105 0.1%
 
4 131 0.2%
 
5 204 0.2%
 
6 486 0.6%
 

Maximum 5 values

ValueCountFrequency (%) 
92 1 < 0.1%
 
91 3 < 0.1%
 
90 1 < 0.1%
 
88 1 < 0.1%
 
87 1 < 0.1%
 

availability_365
Numeric

Distinct count366
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean117.4874573
Minimum0
Maximum365
Zeros (%)34.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median59
Q3247
95-th percentile361
Maximum365
Range365
Interquartile range247

Descriptive statistics

Standard deviation134.179864
Coef of variation1.142078202
Kurtosis-1.059409596
Mean117.4874573
MAD118.3220354
Skewness0.7382274872
Sum9835345
Variance18004.23589
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 4.5 8.5 ... 361.5 362.5 363.5 364.5 365. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 28598 34.2%
 
365 2003 2.4%
 
364 1200 1.4%
 
1 825 1.0%
 
89 667 0.8%
 
90 646 0.8%
 
363 592 0.7%
 
257 575 0.7%
 
179 498 0.6%
 
2 496 0.6%
 
Other values (356) 47614 56.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 28598 34.2%
 
1 825 1.0%
 
2 496 0.6%
 
3 487 0.6%
 
4 408 0.5%
 

Maximum 5 values

ValueCountFrequency (%) 
365 2003 2.4%
 
364 1200 1.4%
 
363 592 0.7%
 
362 339 0.4%
 
361 218 0.3%
 

bathrooms
Numeric

Distinct count22
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.287699787
Minimum0.5
Maximum11
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum0.5
5-th percentile1
Q11
Median1
Q31.5
95-th percentile2.5
Maximum11
Range10.5
Interquartile range0.5

Descriptive statistics

Standard deviation0.566255133
Coef of variation0.4397415753
Kurtosis28.65734089
Mean1.287699787
MAD0.413724314
Skewness3.535919712
Sum107798.5
Variance0.3206448756
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=22)
Histogram
Histogram with variable size bins (bins=[ 0.5 0.75 1.25 1.75 2.25 ... 5.25 8.25 9.75 10.25 11. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 59368 70.9%
 
2 11930 14.3%
 
1.5 7832 9.4%
 
2.5 2285 2.7%
 
3 1227 1.5%
 
3.5 407 0.5%
 
0.5 301 0.4%
 
4 184 0.2%
 
4.5 58 0.1%
 
5 32 < 0.1%
 
Other values (12) 90 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0.5 301 0.4%
 
1 59368 70.9%
 
1.5 7832 9.4%
 
2 11930 14.3%
 
2.5 2285 2.7%
 

Maximum 5 values

ValueCountFrequency (%) 
11 1 < 0.1%
 
10.5 1 < 0.1%
 
10 22 < 0.1%
 
9.5 1 < 0.1%
 
9 1 < 0.1%
 

bed_type
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Real Bed
83017
Pull-out Sofa
 
409
Futon
 
180
Other values (2)
 
108
ValueCountFrequency (%) 
Real Bed 83017 99.2%
 
Pull-out Sofa 409 0.5%
 
Futon 180 0.2%
 
Couch 66 0.1%
 
Airbed 42 0.1%
 
Max length13
Mean length8.014609265
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

bedrooms
Numeric

Distinct count13
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.389624197
Minimum0
Maximum12
Zeros (%)6.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median1
Q32
95-th percentile3
Maximum12
Range12
Interquartile range1

Descriptive statistics

Standard deviation0.8782830515
Coef of variation0.6320291872
Kurtosis5.005449039
Mean1.389624197
MAD0.6633518552
Skewness1.721179109
Sum116331
Variance0.7713811186
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=13)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 4.5 5.5 6.5 7.5 12. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 52924 63.2%
 
2 17290 20.7%
 
3 5564 6.6%
 
0 5142 6.1%
 
4 2062 2.5%
 
5 574 0.7%
 
6 124 0.1%
 
7 20 < 0.1%
 
10 4 < 0.1%
 
8 4 < 0.1%
 
Other values (3) 6 < 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5142 6.1%
 
1 52924 63.2%
 
2 17290 20.7%
 
3 5564 6.6%
 
4 2062 2.5%
 

Maximum 5 values

ValueCountFrequency (%) 
12 1 < 0.1%
 
11 2 < 0.1%
 
10 4 < 0.1%
 
9 3 < 0.1%
 
8 4 < 0.1%
 

beds
Numeric

Distinct count18
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.747879686
Minimum1
Maximum20
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum20
Range19
Interquartile range1

Descriptive statistics

Standard deviation1.197688438
Coef of variation0.6852236158
Kurtosis13.74881602
Mean1.747879686
MAD0.8645008173
Skewness2.766640558
Sum146322
Variance1.434457595
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=18)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 10.5 12.5 13.5 14.5 20. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 48384 57.8%
 
2 20385 24.4%
 
3 8335 10.0%
 
4 3772 4.5%
 
5 1478 1.8%
 
6 742 0.9%
 
7 257 0.3%
 
8 171 0.2%
 
10 67 0.1%
 
9 55 0.1%
 
Other values (8) 68 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 48384 57.8%
 
2 20385 24.4%
 
3 8335 10.0%
 
4 3772 4.5%
 
5 1478 1.8%
 

Maximum 5 values

ValueCountFrequency (%) 
20 2 < 0.1%
 
17 1 < 0.1%
 
16 5 < 0.1%
 
15 2 < 0.1%
 
14 24 < 0.1%
 

calculated_host_listings_count_entire_homes
Numeric

Distinct count79
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean21.12180758
Minimum0
Maximum1127
Zeros (%)36.7%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q32
95-th percentile47
Maximum1127
Range1127
Interquartile range2

Descriptive statistics

Standard deviation128.1197802
Coef of variation6.065758328
Kurtosis68.25770559
Mean21.12180758
MAD35.31703624
Skewness8.274168478
Sum1768191
Variance16414.67809
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 1.795e+02 2.080e+02 2.210e+02 6.745e+02 1.127e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 30756 36.7%
 
1 29891 35.7%
 
2 4215 5.0%
 
3 2075 2.5%
 
4 1519 1.8%
 
5 1160 1.4%
 
1127 1074 1.3%
 
6 854 1.0%
 
7 751 0.9%
 
9 733 0.9%
 
Other values (69) 10686 12.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 30756 36.7%
 
1 29891 35.7%
 
2 4215 5.0%
 
3 2075 2.5%
 
4 1519 1.8%
 

Maximum 5 values

ValueCountFrequency (%) 
1127 1074 1.3%
 
222 226 0.3%
 
220 183 0.2%
 
196 31 < 0.1%
 
163 170 0.2%
 

calculated_host_listings_count_private_rooms
Numeric

Distinct count37
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.928948563
Minimum0
Maximum135
Zeros (%)47.9%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q31
95-th percentile6
Maximum135
Range135
Interquartile range1

Descriptive statistics

Standard deviation8.046097602
Coef of variation4.171234919
Kurtosis165.9288719
Mean1.928948563
MAD2.420513448
Skewness11.76407502
Sum161480
Variance64.73968662
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=37)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 34. 38.5 40. 115.5 135. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 40081 47.9%
 
1 25837 30.9%
 
2 6912 8.3%
 
3 3763 4.5%
 
4 1421 1.7%
 
5 1249 1.5%
 
6 598 0.7%
 
7 557 0.7%
 
10 358 0.4%
 
8 302 0.4%
 
Other values (27) 2636 3.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 40081 47.9%
 
1 25837 30.9%
 
2 6912 8.3%
 
3 3763 4.5%
 
4 1421 1.7%
 

Maximum 5 values

ValueCountFrequency (%) 
135 144 0.2%
 
96 101 0.1%
 
89 93 0.1%
 
41 73 0.1%
 
39 91 0.1%
 

calculated_host_listings_count_shared_rooms
Numeric

Distinct count13
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.04686193468
Minimum0
Maximum18
Zeros (%)98.8%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q30
95-th percentile0
Maximum18
Range18
Interquartile range0

Descriptive statistics

Standard deviation0.6892846374
Coef of variation14.70883868
Kurtosis432.25028
Mean0.04686193468
MAD0.09258526441
Skewness19.82671027
Sum3923
Variance0.4751133113
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=13)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 6.5 9.5 11. 17.5 18. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 82697 98.8%
 
1 658 0.8%
 
12 56 0.1%
 
17 51 0.1%
 
2 45 0.1%
 
8 38 < 0.1%
 
7 36 < 0.1%
 
9 32 < 0.1%
 
4 25 < 0.1%
 
3 24 < 0.1%
 
Other values (3) 52 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 82697 98.8%
 
1 658 0.8%
 
2 45 0.1%
 
3 24 < 0.1%
 
4 25 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
18 22 < 0.1%
 
17 51 0.1%
 
12 56 0.1%
 
10 11 < 0.1%
 
9 32 < 0.1%
 

cancellation_policy
Categorical

Distinct count8
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
strict_14_with_grace_period
35831
flexible
27389
moderate
19854
Other values (5)
 
640
ValueCountFrequency (%) 
strict_14_with_grace_period 35831 42.8%
 
flexible 27389 32.7%
 
moderate 19854 23.7%
 
super_strict_30 336 0.4%
 
super_strict_60 294 0.4%
 
strict 8 < 0.1%
 
luxury_moderate 1 < 0.1%
 
luxury_super_strict_95 1 < 0.1%
 
Max length27
Mean length16.18505865
Min length6
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

cleaning_fee
Numeric

Distinct count234
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean31.28081325
Minimum0
Maximum544
Zeros (%)32.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median20
Q349
95-th percentile100
Maximum544
Range544
Interquartile range49

Descriptive statistics

Standard deviation40.91509115
Coef of variation1.307993204
Kurtosis16.88794751
Mean31.28081325
MAD28.49314137
Skewness3.025822335
Sum2618642
Variance1674.044684
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 2. 4.5 5.5 7.5 ... 299. 300.5 372.5 382. 544. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 26834 32.1%
 
20 5228 6.2%
 
30 5096 6.1%
 
10 4542 5.4%
 
50 3848 4.6%
 
15 3680 4.4%
 
40 3631 4.3%
 
25 3268 3.9%
 
60 2475 3.0%
 
35 1959 2.3%
 
Other values (224) 23153 27.7%
 

Minimum 5 values

ValueCountFrequency (%) 
0 26834 32.1%
 
4 276 0.3%
 
5 1615 1.9%
 
6 214 0.3%
 
7 270 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
544 1 < 0.1%
 
525 2 < 0.1%
 
500 6 < 0.1%
 
496 1 < 0.1%
 
495 1 < 0.1%
 

days_from_last_review
Numeric

Distinct count1772
Unique (%)2.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean180.4394367
Minimum0
Maximum2997
Zeros (%)24.3%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q12
Median29
Q3172
95-th percentile984
Maximum2997
Range2997
Interquartile range170

Descriptive statistics

Standard deviation328.4662462
Coef of variation1.820368387
Kurtosis6.459290616
Mean180.4394367
MAD227.0800209
Skewness2.497362249
Sum15105307
Variance107890.0749
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-01 1.5000e+00 4.5000e+00 5.5000e+00 ... 1.7125e+03 1.7190e+03 1.9110e+03 2.6090e+03 2.9970e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 20338 24.3%
 
20 1267 1.5%
 
14 1236 1.5%
 
19 1117 1.3%
 
7 1094 1.3%
 
15 1086 1.3%
 
21 1059 1.3%
 
16 908 1.1%
 
28 906 1.1%
 
3 845 1.0%
 
Other values (1762) 53858 64.3%
 

Minimum 5 values

ValueCountFrequency (%) 
0 20338 24.3%
 
1 479 0.6%
 
2 778 0.9%
 
3 845 1.0%
 
4 763 0.9%
 

Maximum 5 values

ValueCountFrequency (%) 
2997 1 < 0.1%
 
2886 1 < 0.1%
 
2729 1 < 0.1%
 
2667 1 < 0.1%
 
2663 1 < 0.1%
 

df_index
Numeric

Distinct count83714
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean42409.33231
Minimum0
Maximum85273
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile4214.65
Q121089.25
Median42302.5
Q363682.75
95-th percentile80954.35
Maximum85273
Range85273
Interquartile range42593.5

Descriptive statistics

Standard deviation24606.19318
Coef of variation0.5802070402
Kurtosis-1.19906414
Mean42409.33231
MAD21312.41127
Skewness0.01158616503
Sum3550254845
Variance605464742.7
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 38562.5 38648.5 59993. 60037.5 85273. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2047 1 < 0.1%
 
6870 1 < 0.1%
 
35524 1 < 0.1%
 
33477 1 < 0.1%
 
39622 1 < 0.1%
 
37575 1 < 0.1%
 
60104 1 < 0.1%
 
58057 1 < 0.1%
 
64202 1 < 0.1%
 
62155 1 < 0.1%
 
Other values (83704) 83704 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
0 1 < 0.1%
 
1 1 < 0.1%
 
2 1 < 0.1%
 
3 1 < 0.1%
 
4 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
85273 1 < 0.1%
 
85272 1 < 0.1%
 
85271 1 < 0.1%
 
85270 1 < 0.1%
 
85269 1 < 0.1%
 

experiences_offered
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
none
81989
business
 
595
family
 
489
Other values (2)
 
641
ValueCountFrequency (%) 
none 81989 97.9%
 
business 595 0.7%
 
family 489 0.6%
 
social 426 0.5%
 
romantic 215 0.3%
 
Max length8
Mean length4.060563347
Min length4
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

extra_people
Numeric

Distinct count110
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean7.364371551
Minimum0
Maximum248
Zeros (%)61.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q310
95-th percentile30
Maximum248
Range248
Interquartile range10

Descriptive statistics

Standard deviation13.71240889
Coef of variation1.861993083
Kurtosis51.46412329
Mean7.364371551
MAD9.143762825
Skewness4.980324493
Sum616501
Variance188.0301575
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 1.5 3.5 4.5 5.5 ... 152.5 197.5 205. 223.5 248. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 51037 61.0%
 
10 7871 9.4%
 
15 6419 7.7%
 
20 4818 5.8%
 
25 2256 2.7%
 
5 2249 2.7%
 
30 1675 2.0%
 
50 1012 1.2%
 
12 658 0.8%
 
35 629 0.8%
 
Other values (100) 5090 6.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 51037 61.0%
 
3 1 < 0.1%
 
4 328 0.4%
 
5 2249 2.7%
 
6 238 0.3%
 

Maximum 5 values

ValueCountFrequency (%) 
248 1 < 0.1%
 
247 1 < 0.1%
 
246 1 < 0.1%
 
244 1 < 0.1%
 
243 1 < 0.1%
 

guests_included
Numeric

Distinct count16
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1.588252861
Minimum1
Maximum16
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q11
Median1
Q32
95-th percentile4
Maximum16
Range15
Interquartile range1

Descriptive statistics

Standard deviation1.291904721
Coef of variation0.8134124944
Kurtosis15.05139747
Mean1.588252861
MAD0.8536039914
Skewness3.258953742
Sum132959
Variance1.669017809
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=16)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 ... 10.5 12.5 14.5 15.5 16. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1 60738 72.6%
 
2 12826 15.3%
 
4 5436 6.5%
 
3 1594 1.9%
 
6 1458 1.7%
 
5 820 1.0%
 
8 404 0.5%
 
7 210 0.3%
 
10 100 0.1%
 
9 53 0.1%
 
Other values (6) 75 0.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 60738 72.6%
 
2 12826 15.3%
 
3 1594 1.9%
 
4 5436 6.5%
 
5 820 1.0%
 

Maximum 5 values

ValueCountFrequency (%) 
16 24 < 0.1%
 
15 11 < 0.1%
 
14 3 < 0.1%
 
13 1 < 0.1%
 
12 16 < 0.1%
 

host_days
Numeric

Distinct count3425
Unique (%)4.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1422.561877
Minimum1
Maximum4028
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile146
Q1811
Median1433
Q31962
95-th percentile2749
Maximum4028
Range4027
Interquartile range1151

Descriptive statistics

Standard deviation788.6841516
Coef of variation0.5544111397
Kurtosis-0.6551134337
Mean1422.561877
MAD645.7214456
Skewness0.1595822736
Sum119088345
Variance622022.6911
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[1.0000e+00 2.1500e+01 7.6500e+01 7.9500e+01 8.9500e+01 ... 3.5425e+03 3.5870e+03 3.5895e+03 3.8435e+03 4.0280e+03], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
1578 646 0.8%
 
1577 504 0.6%
 
1410 243 0.3%
 
811 175 0.2%
 
1999 171 0.2%
 
1654 160 0.2%
 
2737 158 0.2%
 
311 143 0.2%
 
1655 134 0.2%
 
1384 130 0.2%
 
Other values (3415) 81250 97.1%
 

Minimum 5 values

ValueCountFrequency (%) 
1 3 < 0.1%
 
2 21 < 0.1%
 
3 28 < 0.1%
 
4 29 < 0.1%
 
5 20 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4028 1 < 0.1%
 
3938 7 < 0.1%
 
3914 1 < 0.1%
 
3894 3 < 0.1%
 
3873 1 < 0.1%
 

host_has_profile_pic
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
83487
0
 
227
ValueCountFrequency (%) 
1 83487 99.7%
 
0 227 0.3%
 

host_identity_verified
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
53468
1
30246
ValueCountFrequency (%) 
0 53468 63.9%
 
1 30246 36.1%
 

host_is_superhost
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
71364
1
 
12350
ValueCountFrequency (%) 
0 71364 85.2%
 
1 12350 14.8%
 

instant_bookable
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
47387
1
36327
ValueCountFrequency (%) 
0 47387 56.6%
 
1 36327 43.4%
 

is_location_exact
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
1
52119
0
31595
ValueCountFrequency (%) 
1 52119 62.3%
 
0 31595 37.7%
 

neighbourhood_cleansed
Categorical

Distinct count33
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Westminster
 
9265
Tower Hamlets
 
8163
Hackney
 
6207
Other values (30)
60079
ValueCountFrequency (%) 
Westminster 9265 11.1%
 
Tower Hamlets 8163 9.8%
 
Hackney 6207 7.4%
 
Camden 5857 7.0%
 
Kensington and Chelsea 5643 6.7%
 
Islington 5076 6.1%
 
Southwark 4833 5.8%
 
Lambeth 4826 5.8%
 
Wandsworth 4313 5.2%
 
Hammersmith and Fulham 4129 4.9%
 
Other values (23) 25402 30.3%
 
Max length22
Mean length10.57815897
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

number_of_reviews
Numeric

Distinct count411
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean17.05203431
Minimum0
Maximum690
Zeros (%)24.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q11
Median4
Q317
95-th percentile78
Maximum690
Range690
Interquartile range16

Descriptive statistics

Standard deviation35.9341873
Coef of variation2.107325534
Kurtosis38.09496993
Mean17.05203431
MAD19.97122687
Skewness4.997203254
Sum1427494
Variance1291.265817
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.000e+00 5.000e-01 1.500e+00 2.500e+00 3.500e+00 ... 2.375e+02 2.805e+02 3.505e+02 5.130e+02 6.900e+02], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 20108 24.0%
 
1 9108 10.9%
 
2 5862 7.0%
 
3 4474 5.3%
 
4 3589 4.3%
 
5 2833 3.4%
 
6 2457 2.9%
 
7 2071 2.5%
 
8 1896 2.3%
 
9 1681 2.0%
 
Other values (401) 29635 35.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 20108 24.0%
 
1 9108 10.9%
 
2 5862 7.0%
 
3 4474 5.3%
 
4 3589 4.3%
 

Maximum 5 values

ValueCountFrequency (%) 
690 1 < 0.1%
 
633 1 < 0.1%
 
612 1 < 0.1%
 
595 1 < 0.1%
 
591 1 < 0.1%
 

number_of_reviews_ltm
Numeric

Distinct count146
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.692464821
Minimum0
Maximum231
Zeros (%)41.2%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median1
Q38
95-th percentile31
Maximum231
Range231
Interquartile range8

Descriptive statistics

Standard deviation12.78074642
Coef of variation1.909721868
Kurtosis20.39359882
Mean6.692464821
MAD7.951796538
Skewness3.7316992
Sum560253
Variance163.347479
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 0.5 1.5 2.5 3.5 ... 82.5 96.5 111.5 136. 231. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 34474 41.2%
 
1 8208 9.8%
 
2 5367 6.4%
 
3 4074 4.9%
 
4 3343 4.0%
 
5 2705 3.2%
 
6 2299 2.7%
 
7 2012 2.4%
 
8 1716 2.0%
 
9 1561 1.9%
 
Other values (136) 17955 21.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 34474 41.2%
 
1 8208 9.8%
 
2 5367 6.4%
 
3 4074 4.9%
 
4 3343 4.0%
 

Maximum 5 values

ValueCountFrequency (%) 
231 1 < 0.1%
 
200 1 < 0.1%
 
185 1 < 0.1%
 
182 1 < 0.1%
 
180 1 < 0.1%
 

price
Numeric

Distinct count493
Unique (%)0.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean104.6837088
Minimum0
Maximum500
Zeros (%)< 0.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile25
Q145
Median80
Q3132
95-th percentile280
Maximum500
Range500
Interquartile range87

Descriptive statistics

Standard deviation83.23632013
Coef of variation0.795122002
Kurtosis4.475333612
Mean104.6837088
MAD60.27010665
Skewness1.924497656
Sum8763492
Variance6928.284988
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 3. 6.5 9.5 10.5 ... 494.5 495.5 498.5 499.5 500. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
50 3106 3.7%
 
100 3065 3.7%
 
40 2795 3.3%
 
35 2529 3.0%
 
30 2363 2.8%
 
120 2358 2.8%
 
45 2303 2.8%
 
150 2280 2.7%
 
60 2245 2.7%
 
80 2226 2.7%
 
Other values (483) 58444 69.8%
 

Minimum 5 values

ValueCountFrequency (%) 
0 18 < 0.1%
 
6 1 < 0.1%
 
7 5 < 0.1%
 
8 24 < 0.1%
 
9 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
500 293 0.4%
 
499 29 < 0.1%
 
498 3 < 0.1%
 
497 6 < 0.1%
 
496 1 < 0.1%
 

property_type
Categorical

Distinct count43
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Apartment
55639
House
17520
Townhouse
 
2916
Other values (40)
 
7639
ValueCountFrequency (%) 
Apartment 55639 66.5%
 
House 17520 20.9%
 
Townhouse 2916 3.5%
 
Condominium 2651 3.2%
 
Serviced apartment 1624 1.9%
 
Loft 725 0.9%
 
Bed and breakfast 638 0.8%
 
Guest suite 364 0.4%
 
Guesthouse 295 0.4%
 
Boutique hotel 220 0.3%
 
Other values (33) 1122 1.3%
 
Max length29
Mean length8.412117447
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

require_guest_phone_verification
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
82292
1
 
1422
ValueCountFrequency (%) 
0 82292 98.3%
 
1 1422 1.7%
 

require_guest_profile_picture
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
82858
1
 
856
ValueCountFrequency (%) 
0 82858 99.0%
 
1 856 1.0%
 

requires_license
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
83712
1
 
2
ValueCountFrequency (%) 
0 83712 > 99.9%
 
1 2 < 0.1%
 

review_scores_rating
Numeric

Distinct count62
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean68.46814153
Minimum0
Maximum100
Zeros (%)26.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median92
Q398
95-th percentile100
Maximum100
Range100
Interquartile range98

Descriptive statistics

Standard deviation41.51839028
Coef of variation0.6063899115
Kurtosis-0.9356146498
Mean68.46814153
MAD36.35211918
Skewness-0.9780343621
Sum5731742
Variance1723.776732
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 10. 25. 36.5 42. ... 94.5 95.5 98.5 99.5 100. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 21757 26.0%
 
100 17630 21.1%
 
98 3849 4.6%
 
97 3710 4.4%
 
96 3619 4.3%
 
93 3593 4.3%
 
90 3337 4.0%
 
95 3307 4.0%
 
80 3264 3.9%
 
99 2492 3.0%
 
Other values (52) 17156 20.5%
 

Minimum 5 values

ValueCountFrequency (%) 
0 21757 26.0%
 
20 288 0.3%
 
30 9 < 0.1%
 
32 1 < 0.1%
 
33 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
100 17630 21.1%
 
99 2492 3.0%
 
98 3849 4.6%
 
97 3710 4.4%
 
96 3619 4.3%
 

reviews_per_month
Numeric

Distinct count932
Unique (%)1.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean0.8975153499
Minimum0
Maximum48.21
Zeros (%)24.0%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10.02
Median0.39
Q31.22
95-th percentile3.52
Maximum48.21
Range48.21
Interquartile range1.2

Descriptive statistics

Standard deviation1.302883722
Coef of variation1.4516562
Kurtosis31.15095907
Mean0.8975153499
MAD0.901030508
Skewness3.162061002
Sum75134.6
Variance1.697505993
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[0.0000e+00 5.0000e-03 1.5000e-02 5.5000e-02 6.5000e-02 ... 8.0050e+00 1.0060e+01 1.1260e+01 1.5345e+01 4.8210e+01], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 20108 24.0%
 
1 1844 2.2%
 
0.04 1057 1.3%
 
0.08 1019 1.2%
 
0.05 945 1.1%
 
0.02 915 1.1%
 
0.07 908 1.1%
 
0.03 891 1.1%
 
0.12 791 0.9%
 
0.06 789 0.9%
 
Other values (922) 54447 65.0%
 

Minimum 5 values

ValueCountFrequency (%) 
0 20108 24.0%
 
0.01 34 < 0.1%
 
0.02 915 1.1%
 
0.03 891 1.1%
 
0.04 1057 1.3%
 

Maximum 5 values

ValueCountFrequency (%) 
48.21 1 < 0.1%
 
24.39 1 < 0.1%
 
15.52 1 < 0.1%
 
15.17 1 < 0.1%
 
14.72 1 < 0.1%
 

room_type
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Entire home/apt
45792
Private room
35870
Hotel room
 
1423
ValueCountFrequency (%) 
Entire home/apt 45792 54.7%
 
Private room 35870 42.8%
 
Hotel room 1423 1.7%
 
Shared room 629 0.8%
 
Max length15
Mean length13.59950546
Min length10
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

security_deposit
Numeric

Distinct count362
Unique (%)0.4%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean121.9345988
Minimum0
Maximum4098
Zeros (%)58.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median0
Q3200
95-th percentile500
Maximum4098
Range4098
Interquartile range200

Descriptive statistics

Standard deviation249.6694338
Coef of variation2.047568421
Kurtosis62.92028734
Mean121.9345988
MAD148.7796856
Skewness6.003136015
Sum10207633
Variance62334.82617
Memory size654.1 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 28. 58.5 64.5 65.5 ... 3450. 3519.5 3760.5 3951.5 4098. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 48622 58.1%
 
100 6004 7.2%
 
200 4973 5.9%
 
250 3600 4.3%
 
300 3276 3.9%
 
500 3139 3.7%
 
150 2891 3.5%
 
85 1945 2.3%
 
495 1233 1.5%
 
350 1002 1.2%
 
Other values (352) 7029 8.4%
 

Minimum 5 values

ValueCountFrequency (%) 
0 48622 58.1%
 
56 1 < 0.1%
 
57 1 < 0.1%
 
60 16 < 0.1%
 
61 6 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
4098 1 < 0.1%
 
4051 1 < 0.1%
 
4049 1 < 0.1%
 
4040 1 < 0.1%
 
4003 1 < 0.1%
 

Correlations

Missing values

Sample

First rows

accommodatesamenities_countavailability_365bathroomsbed_typebedroomsbedscalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscancellation_policycleaning_feedays_from_last_reviewdf_indexexperiences_offeredextra_peopleguests_includedhost_dayshost_has_profile_pichost_identity_verifiedhost_is_superhostinstant_bookableis_location_exactneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_ratingreviews_per_monthroom_typesecurity_deposit
04.023344.01.0Real Bed1.01.02.00.00.0strict_14_with_grace_period30.067.00family20.02.03634.011111Lambeth184.01.088.0Apartment10092.01.59Entire home/apt400.0
12.055353.01.0Real Bed1.01.01.02.00.0moderate15.097.01business15.01.03590.010001Islington16.02.065.0Apartment00096.00.14Private room100.0
22.029114.01.0Real Bed1.01.01.00.00.0strict_14_with_grace_period50.019.02romantic0.02.03571.011111Kensington and Chelsea87.06.0100.0Apartment11096.00.73Entire home/apt150.0
36.031265.02.0Real Bed3.04.015.00.00.0strict_14_with_grace_period65.088.03none10.04.03541.011111Westminster41.05.0300.0Apartment00094.00.40Entire home/apt350.0
42.027346.01.5Real Bed1.01.01.00.00.0moderate70.099.04family0.02.03639.011001Wandsworth93.01.0175.0Townhouse11098.00.86Entire home/apt250.0
54.022147.01.0Real Bed2.02.01.00.00.0moderate50.052.05none11.02.03452.010011Wandsworth31.05.065.0Apartment00092.00.72Entire home/apt250.0
62.017288.01.5Real Bed1.01.00.03.00.0strict_14_with_grace_period0.079.06none8.01.03450.010111Barnet122.05.029.0House00095.01.06Private room100.0
74.036339.01.0Real Bed1.03.03.00.00.0strict_14_with_grace_period75.055.07none15.03.03436.011011Islington63.09.0147.0Apartment00085.00.58Entire home/apt100.0
82.025336.01.5Real Bed1.01.00.02.00.0strict_14_with_grace_period10.077.08none12.01.03396.011101Newham115.010.034.0Townhouse11097.01.03Private room0.0
92.014365.01.0Real Bed1.01.00.01.00.0flexible0.0112.09none0.01.03380.011001Hounslow5.02.0100.0House00088.00.05Private room0.0

Last rows

accommodatesamenities_countavailability_365bathroomsbed_typebedroomsbedscalculated_host_listings_count_entire_homescalculated_host_listings_count_private_roomscalculated_host_listings_count_shared_roomscancellation_policycleaning_feedays_from_last_reviewdf_indexexperiences_offeredextra_peopleguests_includedhost_dayshost_has_profile_pichost_identity_verifiedhost_is_superhostinstant_bookableis_location_exactneighbourhood_cleansednumber_of_reviewsnumber_of_reviews_ltmpriceproperty_typerequire_guest_phone_verificationrequire_guest_profile_picturerequires_licensereview_scores_ratingreviews_per_monthroom_typesecurity_deposit
837041.011173.01.0Real Bed1.01.01.00.00.0flexible0.00.085264none0.01.01.010010Redbridge0.00.0101.0House0000.00.0Entire home/apt0.0
837054.018307.01.0Real Bed2.02.01.00.00.0flexible0.00.085265none0.01.01190.010010Richmond upon Thames0.00.0105.0House0000.00.0Entire home/apt0.0
837062.01680.01.0Real Bed1.02.01.00.00.0flexible0.00.085266none0.01.01522.010010Lewisham0.00.078.0Apartment0000.00.0Entire home/apt0.0
837072.01473.01.0Real Bed1.01.01.00.00.0strict_14_with_grace_period0.00.085267none0.01.0133.010011Enfield0.00.030.0Apartment0000.00.0Entire home/apt100.0
837082.01430.01.0Real Bed2.02.00.01.00.0flexible0.00.085268none0.01.02564.010010Kensington and Chelsea0.00.056.0Apartment0000.00.0Private room0.0
837095.01545.01.5Real Bed1.03.07.00.00.0flexible40.00.085269none0.01.0415.010010Ealing0.00.085.0Apartment0000.00.0Entire home/apt0.0
837102.0162.02.0Real Bed1.01.00.02.00.0flexible0.00.085270none0.01.0733.010000Camden0.00.035.0Apartment0000.00.0Private room0.0
837116.022173.04.0Real Bed3.03.01.00.00.0flexible0.00.085271none0.01.01.010001Westminster0.00.0420.0Condominium0000.00.0Entire home/apt0.0
837122.015233.01.0Real Bed1.01.00.01.00.0flexible0.00.085272none0.01.01.010001Hillingdon0.00.035.0House0000.00.0Private room81.0
837135.01132.01.0Real Bed2.02.02.01.00.0flexible0.00.085273none0.01.02326.011001Lambeth0.00.050.0Apartment0000.00.0Entire home/apt0.0